USE [Miles]
GO

/****** Object:  Table [dbo].[PR]    Script Date: 05/24/2010 17:43:54 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Wicresoft.Platform.Processes.Mobile](
	[Id] [uniqueidentifier] NOT NULL,
	
	[LaunchTime] [datetime] NOT NULL,
	[MobileName] [nvarchar](50) NOT NULL,
	[LaunchBy] [nvarchar](50) NULL,
	[LaunchComment] [nvarchar](250) NULL,
	[DeployMethod] [nvarchar](10) NULL,
	
	
	--bookmark 1: purchase
	[PurchaseTime] [datetime] NULL,
	[PurchaseBy] [nvarchar](50) NULL,
	[PurchaseComment] [nvarchar](250) NULL,
	
	
	--bookmark 2: find a developer
	[AssignTime] [datetime] NULL,
	[AssignBy] [nvarchar](50) NULL,
	[AssignComment] [nvarchar](250) NULL,
	[Developer] [nvarchar](50) NULL,
	[DeveloperETA] [datetime] NULL,
	[TestETA] [datetime] NULL,
	
	--bookmark 3: dev phase
	[DevCompleteTime] [datetime] NULL,
	[DevCompleteBy] [nvarchar](50) NULL,
	[DevCompleteComment] [nvarchar](250) NULL,
	[ReleasePackage] [nvarchar](50) NULL,
	[ReleaseDocument] [nvarchar](50) NULL,
	
	--bookmark 4: test phase
	[TestCompleteTime] [datetime] NULL,
	[TestCompleteBy] [nvarchar](50) NULL,
	[TestCompleteComment] [nvarchar](250) NULL,
	[TestResult] [bit] NULL,
	[TestDocument] [nvarchar](50) NULL,
	

	--shared info
	[AssignedTo] [nvarchar](50) NULL,
	[CurrentState] [nvarchar](10) NULL,
	[LastModifiedTime] [datetime] NULL,
	[LastModifiedBy] [nvarchar](50) NULL,
	
 CONSTRAINT [PK_Wicresoft.Platform.Processes.Mobile] PRIMARY KEY CLUSTERED 
(
	[LaunchTime] ASC,
	[MobileName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


GO


